SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROC [dbo].[usp_ChiTietTour_ThongTinHDV]
	@MaTour CHAR(20)
AS
Begin
	SELECT  MA_TOUR, HO_TEN, DIA_CHI, DIEN_THOAI
	FROM	TOUR_HDV THDV JOIN HUONG_DAN_VIEN HDV ON THDV.MA_HDV = HDV.MA_HDV
	WHERE	MA_TOUR = @MaTour
END

GO
